If Dir("C:\test.Txt") <> "" Then
    MsgBox " "
Else
    MsgBox "  "
End If  